package org.cangku.dao;

import org.apache.ibatis.annotations.Param;
import org.cangku.entity.Shopsale;

import java.util.List;

public interface ShopSaleDao {

    public List<Shopsale> query(@Param("bid") int bid,@Param("fid") int fid,@Param("date1") String date1,@Param("date2") String date2,@Param("offset") int offset,@Param("limit") int limit);

    public int getCount(@Param("bid") int bid,@Param("fid") int fid,@Param("date1") String date1,@Param("date2") String date2);
    public int insert(Shopsale shopsale);

    /*会员消费查询*/
    public List<Shopsale> memberquery(@Param("phone") String phone,@Param("date1") String date1,@Param("date2") String date2,@Param("offset") int offset,@Param("limit") int limit);
    public int membercount(@Param("phone") String phone,@Param("date1") String date1,@Param("date2") String date2);
    /*根据手机号获得还手机号的总金额*/
    public double getZongJineByPhone(@Param("phone") String phone);
}
